USE [totem]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[consultarTodasPlantillas]

@tipoplantilla int
AS

BEGIN


SELECT [ID_PLANTILLA]
,[NOMBRE_PLANTILLA]
FROM [totem].[dbo].[PLANTILLA]
WHERE ID_TP = @tipoplantilla

END

SET ANSI_NULLS ON
GO